Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | StockItem(AS_ITM_STK) |
ProductGroupCode | Specifies the product group of the Item for calculation of temperature corrected volume. Defined by ASTM D 1250 table 54 or American Petroleum Institute (API) Std 2540 table 6 | CD_PDT_GP | Code | varchar(20) | |
ReferenceDensity | The reference density at reference temperature of the product, used for calculating the volume correction factor. Cf. ASTM D 1250 table 54 or American Petroleum Institute (API) Std 2540 table 6 | QU_DNSTY_RFC | Quantity | DECIMAL(9,3) | |